﻿DELETE FROM NewsMessage;
DELETE FROM NewsFeed;
--DBCC CHECKIDENT(NewsFeed,RESEED, 0);

DECLARE @lastCompID bigint;
DECLARE @lastDesignGroupID bigint;

INSERT INTO NewsFeed(date) VALUES(10/10/2009);
SET @lastCompID = SCOPE_IDENTITY();
INSERT INTO NewsMessage(Code, NewsFeedId,Message) VALUES('en', @lastCompID, N'We are open now');
INSERT INTO NewsMessage(Code, NewsFeedId,Message) VALUES('ru', @lastCompID, N'Мы уже открились');

INSERT INTO NewsFeed(date) VALUES(10/10/2009);
SET @lastCompID = SCOPE_IDENTITY();
INSERT INTO NewsMessage(Code, NewsFeedId,Message) VALUES('en', @lastCompID, N'We are open now');
INSERT INTO NewsMessage(Code, NewsFeedId,Message) VALUES('ru', @lastCompID, N'Мы уже открились');

INSERT INTO NewsFeed(date) VALUES(10/10/2009);
SET @lastCompID = SCOPE_IDENTITY();
INSERT INTO NewsMessage(Code, NewsFeedId,Message) VALUES('en', @lastCompID, N'We are open now');
INSERT INTO NewsMessage(Code, NewsFeedId,Message) VALUES('ru', @lastCompID, N'Мы уже открились');

INSERT INTO NewsFeed(date) VALUES(10/10/2009);
SET @lastCompID = SCOPE_IDENTITY();
INSERT INTO NewsMessage(Code, NewsFeedId,Message) VALUES('en', @lastCompID, N'We are open now');
INSERT INTO NewsMessage(Code, NewsFeedId,Message) VALUES('ru', @lastCompID, N'Мы уже открились');

INSERT INTO NewsFeed(date) VALUES(10/10/2009);
SET @lastCompID = SCOPE_IDENTITY();
INSERT INTO NewsMessage(Code, NewsFeedId,Message) VALUES('en', @lastCompID, N'We are open now');
INSERT INTO NewsMessage(Code, NewsFeedId,Message) VALUES('ru', @lastCompID, N'Мы уже открились');



DELETE FROM ProductToDataTemplate;

DELETE FROM ProductToPrintMedia;

DELETE FROM Product;
--DBCC CHECKIDENT(Product,RESEED, 0);

DELETE FROM DesignGroup;
--DBCC CHECKIDENT(DesignGroup,RESEED, 0);
INSERT INTO DesignGroup(LocaleNameKey) VALUES ('product.design.group.simple');
SET @lastDesignGroupID = SCOPE_IDENTITY();


--INSERT INTO LocalizedMessage(LanguageCode, "Key", Message) VALUES ('en',	'product.bcard.simple',	N'Simple business card');
--INSERT INTO LocalizedMessage(LanguageCode, "Key", Message) VALUES ('ru',	'product.bcard.simple',	N'Обычная визитки');

DELETE FROM DataTemplate;
--DBCC CHECKIDENT(DataTemplate,RESEED, 0);


INSERT INTO DataTemplate(TemplateXML, LocaleNameKey) VALUES('<?xml version="1.0" encoding="utf-8"?><InfoTemplate xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"><Items><TextItem><FieldName>companyName</FieldName><FontId>1</FontId><Size>20</Size><Color>FF3333EE</Color><Align><X>0</X><Y>110</Y><Halign>center</Halign><GrowTo>middle</GrowTo></Align><CMYK><C>79</C><M>79</M><Y>0</Y><K>7</K></CMYK></TextItem><TextItem><FieldName>companyMessage</FieldName><FontId>1</FontId><Size>10</Size><Color>FF333333</Color><Align><X>0</X><Y>90</Y><Halign>center</Halign><GrowTo>middle</GrowTo></Align><CMYK><C>0</C><M>0</M><Y>0</Y><K>80</K></CMYK></TextItem><TextItem><FieldName>fullName</FieldName><FontId>1</FontId><Size>12</Size><Color>FF333333</Color><Align><X>0</X><Y>75</Y><Halign>center</Halign><GrowTo>middle</GrowTo></Align><CMYK><C>0</C><M>0</M><Y>0</Y><K>80</K></CMYK></TextItem><TextItem><FieldName>email</FieldName><FontId>1</FontId><Size>12</Size><Color>FF333333</Color><Align><X>0</X><Y>60</Y><Halign>center</Halign><GrowTo>middle</GrowTo></Align><CMYK><C>0</C><M>0</M><Y>0</Y><K>80</K></CMYK></TextItem><TextItem><FieldName>addressLine1</FieldName><FontId>1</FontId><Size>10</Size><Color>FF333333</Color><Align><X>10</X><Y>30</Y><Halign>abs</Halign><GrowTo>right</GrowTo></Align><CMYK><C>0</C><M>0</M><Y>0</Y><K>80</K></CMYK></TextItem><TextItem><FieldName>addressLine2</FieldName><FontId>1</FontId><Size>10</Size><Color>FF333333</Color><Align><X>10</X><Y>15</Y><Halign>abs</Halign><GrowTo>right</GrowTo></Align><CMYK><C>0</C><M>0</M><Y>0</Y><K>80</K></CMYK></TextItem><TextItem><FieldName>phone</FieldName><FontId>1</FontId><Size>10</Size><Color>FF333333</Color><Align><X>245</X><Y>30</Y><Halign>abs</Halign><GrowTo>left</GrowTo></Align><CMYK><C>0</C><M>0</M><Y>0</Y><K>80</K></CMYK></TextItem><TextItem><FieldName>mobile</FieldName><FontId>1</FontId><Size>10</Size><Color>FF333333</Color><Align><X>245</X><Y>15</Y><Halign>abs</Halign><GrowTo>left</GrowTo></Align><CMYK><C>0</C><M>0</M><Y>0</Y><K>80</K></CMYK></TextItem></Items><Width>255.118</Width><Height>141.732</Height></InfoTemplate>', 'bcard_middle');
INSERT INTO DataTemplate(TemplateXML, LocaleNameKey) VALUES('<?xml version="1.0" encoding="utf-8"?><InfoTemplate xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"><Items><TextItem><FieldName>companyName</FieldName><FontId>1</FontId><Size>20</Size><Color>FF3333EE</Color><Align><X>0</X><Y>110</Y><Halign>center</Halign><GrowTo>middle</GrowTo></Align><CMYK><C>79</C><M>79</M><Y>0</Y><K>7</K></CMYK></TextItem><TextItem><FieldName>companyMessage</FieldName><FontId>1</FontId><Size>10</Size><Color>FF333333</Color><Align><X>0</X><Y>90</Y><Halign>center</Halign><GrowTo>middle</GrowTo></Align><CMYK><C>0</C><M>0</M><Y>0</Y><K>80</K></CMYK></TextItem><TextItem><FieldName>fullName</FieldName><FontId>1</FontId><Size>12</Size><Color>FF333333</Color><Align><X>0</X><Y>75</Y><Halign>center</Halign><GrowTo>middle</GrowTo></Align><CMYK><C>0</C><M>0</M><Y>0</Y><K>80</K></CMYK></TextItem><TextItem><FieldName>email</FieldName><FontId>1</FontId><Size>12</Size><Color>FF333333</Color><Align><X>0</X><Y>60</Y><Halign>center</Halign><GrowTo>middle</GrowTo></Align><CMYK><C>0</C><M>0</M><Y>0</Y><K>80</K></CMYK></TextItem><TextItem><FieldName>addressLine1</FieldName><FontId>1</FontId><Size>10</Size><Color>FF333333</Color><Align><X>10</X><Y>30</Y><Halign>abs</Halign><GrowTo>right</GrowTo></Align><CMYK><C>0</C><M>0</M><Y>0</Y><K>80</K></CMYK></TextItem><TextItem><FieldName>addressLine2</FieldName><FontId>1</FontId><Size>10</Size><Color>FF333333</Color><Align><X>10</X><Y>15</Y><Halign>abs</Halign><GrowTo>right</GrowTo></Align><CMYK><C>0</C><M>0</M><Y>0</Y><K>80</K></CMYK></TextItem><TextItem><FieldName>phone</FieldName><FontId>1</FontId><Size>10</Size><Color>FF333333</Color><Align><X>245</X><Y>30</Y><Halign>abs</Halign><GrowTo>left</GrowTo></Align><CMYK><C>0</C><M>0</M><Y>0</Y><K>80</K></CMYK></TextItem><TextItem><FieldName>mobile</FieldName><FontId>1</FontId><Size>10</Size><Color>FF333333</Color><Align><X>245</X><Y>15</Y><Halign>abs</Halign><GrowTo>left</GrowTo></Align><CMYK><C>0</C><M>0</M><Y>0</Y><K>80</K></CMYK></TextItem></Items><Width>255.118</Width><Height>141.732</Height></InfoTemplate>', 'bcard_left');
INSERT INTO DataTemplate(TemplateXML, LocaleNameKey) VALUES('<?xml version="1.0" encoding="utf-8"?><InfoTemplate xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"><Items><TextItem><FieldName>companyName</FieldName><FontId>1</FontId><Size>20</Size><Color>FF3333EE</Color><Align><X>0</X><Y>110</Y><Halign>center</Halign><GrowTo>middle</GrowTo></Align><CMYK><C>79</C><M>79</M><Y>0</Y><K>7</K></CMYK></TextItem><TextItem><FieldName>companyMessage</FieldName><FontId>1</FontId><Size>10</Size><Color>FF333333</Color><Align><X>0</X><Y>90</Y><Halign>center</Halign><GrowTo>middle</GrowTo></Align><CMYK><C>0</C><M>0</M><Y>0</Y><K>80</K></CMYK></TextItem><TextItem><FieldName>fullName</FieldName><FontId>1</FontId><Size>12</Size><Color>FF333333</Color><Align><X>0</X><Y>75</Y><Halign>center</Halign><GrowTo>middle</GrowTo></Align><CMYK><C>0</C><M>0</M><Y>0</Y><K>80</K></CMYK></TextItem><TextItem><FieldName>email</FieldName><FontId>1</FontId><Size>12</Size><Color>FF333333</Color><Align><X>0</X><Y>60</Y><Halign>center</Halign><GrowTo>middle</GrowTo></Align><CMYK><C>0</C><M>0</M><Y>0</Y><K>80</K></CMYK></TextItem><TextItem><FieldName>addressLine1</FieldName><FontId>1</FontId><Size>10</Size><Color>FF333333</Color><Align><X>10</X><Y>30</Y><Halign>abs</Halign><GrowTo>right</GrowTo></Align><CMYK><C>0</C><M>0</M><Y>0</Y><K>80</K></CMYK></TextItem><TextItem><FieldName>addressLine2</FieldName><FontId>1</FontId><Size>10</Size><Color>FF333333</Color><Align><X>10</X><Y>15</Y><Halign>abs</Halign><GrowTo>right</GrowTo></Align><CMYK><C>0</C><M>0</M><Y>0</Y><K>80</K></CMYK></TextItem><TextItem><FieldName>phone</FieldName><FontId>1</FontId><Size>10</Size><Color>FF333333</Color><Align><X>245</X><Y>30</Y><Halign>abs</Halign><GrowTo>left</GrowTo></Align><CMYK><C>0</C><M>0</M><Y>0</Y><K>80</K></CMYK></TextItem><TextItem><FieldName>mobile</FieldName><FontId>1</FontId><Size>10</Size><Color>FF333333</Color><Align><X>245</X><Y>15</Y><Halign>abs</Halign><GrowTo>left</GrowTo></Align><CMYK><C>0</C><M>0</M><Y>0</Y><K>80</K></CMYK></TextItem></Items><Width>255.118</Width><Height>141.732</Height></InfoTemplate>', 'bcard_right');
INSERT INTO DataTemplate(TemplateXML, LocaleNameKey) VALUES('<?xml version="1.0" encoding="utf-8"?><InfoTemplate xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"><Items><TextItem><FieldName>companyName</FieldName><FontId>1</FontId><Size>20</Size><Color>FF3333EE</Color><Align><X>0</X><Y>110</Y><Halign>center</Halign><GrowTo>middle</GrowTo></Align><CMYK><C>79</C><M>79</M><Y>0</Y><K>7</K></CMYK></TextItem><TextItem><FieldName>companyMessage</FieldName><FontId>1</FontId><Size>10</Size><Color>FF333333</Color><Align><X>0</X><Y>90</Y><Halign>center</Halign><GrowTo>middle</GrowTo></Align><CMYK><C>0</C><M>0</M><Y>0</Y><K>80</K></CMYK></TextItem><TextItem><FieldName>fullName</FieldName><FontId>1</FontId><Size>12</Size><Color>FF333333</Color><Align><X>0</X><Y>75</Y><Halign>center</Halign><GrowTo>middle</GrowTo></Align><CMYK><C>0</C><M>0</M><Y>0</Y><K>80</K></CMYK></TextItem><TextItem><FieldName>email</FieldName><FontId>1</FontId><Size>12</Size><Color>FF333333</Color><Align><X>0</X><Y>60</Y><Halign>center</Halign><GrowTo>middle</GrowTo></Align><CMYK><C>0</C><M>0</M><Y>0</Y><K>80</K></CMYK></TextItem><TextItem><FieldName>addressLine1</FieldName><FontId>1</FontId><Size>10</Size><Color>FF333333</Color><Align><X>10</X><Y>30</Y><Halign>abs</Halign><GrowTo>right</GrowTo></Align><CMYK><C>0</C><M>0</M><Y>0</Y><K>80</K></CMYK></TextItem><TextItem><FieldName>addressLine2</FieldName><FontId>1</FontId><Size>10</Size><Color>FF333333</Color><Align><X>10</X><Y>15</Y><Halign>abs</Halign><GrowTo>right</GrowTo></Align><CMYK><C>0</C><M>0</M><Y>0</Y><K>80</K></CMYK></TextItem><TextItem><FieldName>phone</FieldName><FontId>1</FontId><Size>10</Size><Color>FF333333</Color><Align><X>245</X><Y>30</Y><Halign>abs</Halign><GrowTo>left</GrowTo></Align><CMYK><C>0</C><M>0</M><Y>0</Y><K>80</K></CMYK></TextItem><TextItem><FieldName>mobile</FieldName><FontId>1</FontId><Size>10</Size><Color>FF333333</Color><Align><X>245</X><Y>15</Y><Halign>abs</Halign><GrowTo>left</GrowTo></Align><CMYK><C>0</C><M>0</M><Y>0</Y><K>80</K></CMYK></TextItem></Items><Width>255.118</Width><Height>141.732</Height></InfoTemplate>', 'bcard_middle_2');
INSERT INTO DataTemplate(TemplateXML, LocaleNameKey) VALUES('<?xml version="1.0" encoding="utf-8"?><InfoTemplate xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"><Items><TextItem><FieldName>companyName</FieldName><FontId>1</FontId><Size>20</Size><Color>FF3333EE</Color><Align><X>0</X><Y>110</Y><Halign>center</Halign><GrowTo>middle</GrowTo></Align><CMYK><C>79</C><M>79</M><Y>0</Y><K>7</K></CMYK></TextItem><TextItem><FieldName>companyMessage</FieldName><FontId>1</FontId><Size>10</Size><Color>FF333333</Color><Align><X>0</X><Y>90</Y><Halign>center</Halign><GrowTo>middle</GrowTo></Align><CMYK><C>0</C><M>0</M><Y>0</Y><K>80</K></CMYK></TextItem><TextItem><FieldName>fullName</FieldName><FontId>1</FontId><Size>12</Size><Color>FF333333</Color><Align><X>0</X><Y>75</Y><Halign>center</Halign><GrowTo>middle</GrowTo></Align><CMYK><C>0</C><M>0</M><Y>0</Y><K>80</K></CMYK></TextItem><TextItem><FieldName>email</FieldName><FontId>1</FontId><Size>12</Size><Color>FF333333</Color><Align><X>0</X><Y>60</Y><Halign>center</Halign><GrowTo>middle</GrowTo></Align><CMYK><C>0</C><M>0</M><Y>0</Y><K>80</K></CMYK></TextItem><TextItem><FieldName>addressLine1</FieldName><FontId>1</FontId><Size>10</Size><Color>FF333333</Color><Align><X>10</X><Y>30</Y><Halign>abs</Halign><GrowTo>right</GrowTo></Align><CMYK><C>0</C><M>0</M><Y>0</Y><K>80</K></CMYK></TextItem><TextItem><FieldName>addressLine2</FieldName><FontId>1</FontId><Size>10</Size><Color>FF333333</Color><Align><X>10</X><Y>15</Y><Halign>abs</Halign><GrowTo>right</GrowTo></Align><CMYK><C>0</C><M>0</M><Y>0</Y><K>80</K></CMYK></TextItem><TextItem><FieldName>phone</FieldName><FontId>1</FontId><Size>10</Size><Color>FF333333</Color><Align><X>245</X><Y>30</Y><Halign>abs</Halign><GrowTo>left</GrowTo></Align><CMYK><C>0</C><M>0</M><Y>0</Y><K>80</K></CMYK></TextItem><TextItem><FieldName>mobile</FieldName><FontId>1</FontId><Size>10</Size><Color>FF333333</Color><Align><X>245</X><Y>15</Y><Halign>abs</Halign><GrowTo>left</GrowTo></Align><CMYK><C>0</C><M>0</M><Y>0</Y><K>80</K></CMYK></TextItem></Items><Width>255.118</Width><Height>141.732</Height></InfoTemplate>', 'bcard_top');
INSERT INTO DataTemplate(TemplateXML, LocaleNameKey) VALUES('<?xml version="1.0" encoding="utf-8"?><InfoTemplate xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"><Items><TextItem><FieldName>companyName</FieldName><FontId>1</FontId><Size>20</Size><Color>FF3333EE</Color><Align><X>0</X><Y>110</Y><Halign>center</Halign><GrowTo>middle</GrowTo></Align><CMYK><C>79</C><M>79</M><Y>0</Y><K>7</K></CMYK></TextItem><TextItem><FieldName>companyMessage</FieldName><FontId>1</FontId><Size>10</Size><Color>FF333333</Color><Align><X>0</X><Y>90</Y><Halign>center</Halign><GrowTo>middle</GrowTo></Align><CMYK><C>0</C><M>0</M><Y>0</Y><K>80</K></CMYK></TextItem><TextItem><FieldName>fullName</FieldName><FontId>1</FontId><Size>12</Size><Color>FF333333</Color><Align><X>0</X><Y>75</Y><Halign>center</Halign><GrowTo>middle</GrowTo></Align><CMYK><C>0</C><M>0</M><Y>0</Y><K>80</K></CMYK></TextItem><TextItem><FieldName>email</FieldName><FontId>1</FontId><Size>12</Size><Color>FF333333</Color><Align><X>0</X><Y>60</Y><Halign>center</Halign><GrowTo>middle</GrowTo></Align><CMYK><C>0</C><M>0</M><Y>0</Y><K>80</K></CMYK></TextItem><TextItem><FieldName>addressLine1</FieldName><FontId>1</FontId><Size>10</Size><Color>FF333333</Color><Align><X>10</X><Y>30</Y><Halign>abs</Halign><GrowTo>right</GrowTo></Align><CMYK><C>0</C><M>0</M><Y>0</Y><K>80</K></CMYK></TextItem><TextItem><FieldName>addressLine2</FieldName><FontId>1</FontId><Size>10</Size><Color>FF333333</Color><Align><X>10</X><Y>15</Y><Halign>abs</Halign><GrowTo>right</GrowTo></Align><CMYK><C>0</C><M>0</M><Y>0</Y><K>80</K></CMYK></TextItem><TextItem><FieldName>phone</FieldName><FontId>1</FontId><Size>10</Size><Color>FF333333</Color><Align><X>245</X><Y>30</Y><Halign>abs</Halign><GrowTo>left</GrowTo></Align><CMYK><C>0</C><M>0</M><Y>0</Y><K>80</K></CMYK></TextItem><TextItem><FieldName>mobile</FieldName><FontId>1</FontId><Size>10</Size><Color>FF333333</Color><Align><X>245</X><Y>15</Y><Halign>abs</Halign><GrowTo>left</GrowTo></Align><CMYK><C>0</C><M>0</M><Y>0</Y><K>80</K></CMYK></TextItem></Items><Width>255.118</Width><Height>141.732</Height></InfoTemplate>', 'bcard_left_2');


INSERT INTO Product(ProductCode,StyleId, IndustryId, LocaleNameKey, DefaultPrintMedia, DesignGroupId, ColorThemeId, CreateDate, DefaultDataTemplateId)
VALUES ('BCARD', 1, 1, 'product.bcard.simple', 'ST250G', @lastDesignGroupID, 1, 10-10-2009, 1);
SET @lastCompID = SCOPE_IDENTITY();
INSERT INTO BusinessCard(BusinessCardId, "Type", CardGroupCode, ImageDataPath) VALUES (@lastCompID, 'USFT', 'NORM', 'some-path');

INSERT INTO Product(ProductCode,StyleId, IndustryId, LocaleNameKey, DefaultPrintMedia, DesignGroupId, ColorThemeId, CreateDate, DefaultDataTemplateId)
VALUES ('BCARD', 1, 1, 'product.bcard.simple1', 'ST250G', @lastDesignGroupID, 1, 10-10-2009, 1);
SET @lastCompID = SCOPE_IDENTITY();
INSERT INTO BusinessCard(BusinessCardId, "Type", CardGroupCode, ImageDataPath) VALUES (@lastCompID, 'USFT', 'NORM', 'some-path');

INSERT INTO Product(ProductCode,StyleId, IndustryId, LocaleNameKey, DefaultPrintMedia, DesignGroupId, ColorThemeId, CreateDate, DefaultDataTemplateId)
VALUES ('BCARD', 1, 1, 'product.bcard.simple3', 'ST250G', @lastDesignGroupID, 1, 10-10-2009, 1);
SET @lastCompID = SCOPE_IDENTITY();
INSERT INTO BusinessCard(BusinessCardId, "Type", CardGroupCode, ImageDataPath) VALUES (@lastCompID, 'USFT', 'NORM', 'some-path');

INSERT INTO Product(ProductCode,StyleId, IndustryId, LocaleNameKey, DefaultPrintMedia, DesignGroupId, ColorThemeId, CreateDate, DefaultDataTemplateId)
VALUES ('BCARD', 1, 1, 'product.bcard.simple4', 'ST250G', @lastDesignGroupID, 1, 10-10-2009, 1);
SET @lastCompID = SCOPE_IDENTITY();
INSERT INTO BusinessCard(BusinessCardId, "Type", CardGroupCode, ImageDataPath) VALUES (@lastCompID, 'USFT', 'NORM', 'some-path');

INSERT INTO Product(ProductCode,StyleId, IndustryId, LocaleNameKey, DefaultPrintMedia, DesignGroupId, ColorThemeId, CreateDate, DefaultDataTemplateId)
VALUES ('BCARD', 1, 1, 'product.bcard.simple5', 'ST250G', @lastDesignGroupID, 1, 10-10-2009, 1);
SET @lastCompID = SCOPE_IDENTITY();
INSERT INTO BusinessCard(BusinessCardId, "Type", CardGroupCode, ImageDataPath) VALUES (@lastCompID, 'USFT', 'NORM', 'some-path');

INSERT INTO Product(ProductCode,StyleId, IndustryId, LocaleNameKey, DefaultPrintMedia, DesignGroupId, ColorThemeId, CreateDate, DefaultDataTemplateId)
VALUES ('BCARD', 1, 1, 'product.bcard.simple6', 'ST250G', @lastDesignGroupID, 1, 10-10-2009, 1);
SET @lastCompID = SCOPE_IDENTITY();
INSERT INTO BusinessCard(BusinessCardId, "Type", CardGroupCode, ImageDataPath) VALUES (@lastCompID, 'USFT', 'NORM', 'some-path');

INSERT INTO Product(ProductCode,StyleId, IndustryId, LocaleNameKey, DefaultPrintMedia, DesignGroupId, ColorThemeId, CreateDate, DefaultDataTemplateId)
VALUES ('BCARD', 1, 1, 'product.bcard.simple7', 'ST250G', @lastDesignGroupID, 1, 10-10-2009, 1);
SET @lastCompID = SCOPE_IDENTITY();
INSERT INTO BusinessCard(BusinessCardId, "Type", CardGroupCode, ImageDataPath) VALUES (@lastCompID, 'USFT', 'NORM', 'some-path');

INSERT INTO Product(ProductCode,StyleId, IndustryId, LocaleNameKey, DefaultPrintMedia, DesignGroupId, ColorThemeId, CreateDate, DefaultDataTemplateId)
VALUES ('BCARD', 1, 1, 'product.bcard.simple8', 'ST250G', @lastDesignGroupID, 1, 10-10-2009, 1);
SET @lastCompID = SCOPE_IDENTITY();
INSERT INTO BusinessCard(BusinessCardId, "Type", CardGroupCode, ImageDataPath) VALUES (@lastCompID, 'USFT', 'NORM', 'some-path');

INSERT INTO Product(ProductCode,StyleId, IndustryId, LocaleNameKey, DefaultPrintMedia, DesignGroupId, ColorThemeId, CreateDate, DefaultDataTemplateId)
VALUES ('BCARD', 1, 1, 'product.bcard.simple9', 'ST250G', @lastDesignGroupID, 1, 10-10-2009, 1);
SET @lastCompID = SCOPE_IDENTITY();
INSERT INTO BusinessCard(BusinessCardId, "Type", CardGroupCode, ImageDataPath) VALUES (@lastCompID, 'USFT', 'NORM', 'some-path');


INSERT INTO ProductToPrintMedia(ProductId, MediaCode) VALUES(1,'ST160G');
INSERT INTO ProductToPrintMedia(ProductId, MediaCode) VALUES(1,'ST220G');
INSERT INTO ProductToPrintMedia(ProductId, MediaCode) VALUES(1,'ST250G');
INSERT INTO ProductToPrintMedia(ProductId, MediaCode) VALUES(1,'ST300G');

INSERT INTO ProductToPrintMedia(ProductId, MediaCode) VALUES(2,'ST160G');
INSERT INTO ProductToPrintMedia(ProductId, MediaCode) VALUES(2,'ST220G');
INSERT INTO ProductToPrintMedia(ProductId, MediaCode) VALUES(2,'ST250G');
INSERT INTO ProductToPrintMedia(ProductId, MediaCode) VALUES(2,'ST300G');

INSERT INTO ProductToPrintMedia(ProductId, MediaCode) VALUES(3,'ST160G');
INSERT INTO ProductToPrintMedia(ProductId, MediaCode) VALUES(3,'ST220G');
INSERT INTO ProductToPrintMedia(ProductId, MediaCode) VALUES(3,'ST250G');
INSERT INTO ProductToPrintMedia(ProductId, MediaCode) VALUES(3,'ST300G');

INSERT INTO ProductToPrintMedia(ProductId, MediaCode) VALUES(4,'ST160G');
INSERT INTO ProductToPrintMedia(ProductId, MediaCode) VALUES(4,'ST220G');
INSERT INTO ProductToPrintMedia(ProductId, MediaCode) VALUES(4,'ST250G');
INSERT INTO ProductToPrintMedia(ProductId, MediaCode) VALUES(4,'ST300G');

INSERT INTO ProductToPrintMedia(ProductId, MediaCode) VALUES(5,'ST160G');
INSERT INTO ProductToPrintMedia(ProductId, MediaCode) VALUES(5,'ST220G');
INSERT INTO ProductToPrintMedia(ProductId, MediaCode) VALUES(5,'ST250G');
INSERT INTO ProductToPrintMedia(ProductId, MediaCode) VALUES(5,'ST300G');

INSERT INTO ProductToPrintMedia(ProductId, MediaCode) VALUES(6,'ST160G');
INSERT INTO ProductToPrintMedia(ProductId, MediaCode) VALUES(6,'ST220G');
INSERT INTO ProductToPrintMedia(ProductId, MediaCode) VALUES(6,'ST250G');
INSERT INTO ProductToPrintMedia(ProductId, MediaCode) VALUES(6,'ST300G');

INSERT INTO ProductToPrintMedia(ProductId, MediaCode) VALUES(7,'ST160G');
INSERT INTO ProductToPrintMedia(ProductId, MediaCode) VALUES(7,'ST220G');
INSERT INTO ProductToPrintMedia(ProductId, MediaCode) VALUES(7,'ST250G');
INSERT INTO ProductToPrintMedia(ProductId, MediaCode) VALUES(7,'ST300G');

INSERT INTO ProductToPrintMedia(ProductId, MediaCode) VALUES(8,'ST160G');
INSERT INTO ProductToPrintMedia(ProductId, MediaCode) VALUES(8,'ST220G');
INSERT INTO ProductToPrintMedia(ProductId, MediaCode) VALUES(8,'ST250G');
INSERT INTO ProductToPrintMedia(ProductId, MediaCode) VALUES(8,'ST300G');

INSERT INTO ProductToPrintMedia(ProductId, MediaCode) VALUES(9,'ST160G');
INSERT INTO ProductToPrintMedia(ProductId, MediaCode) VALUES(9,'ST220G');
INSERT INTO ProductToPrintMedia(ProductId, MediaCode) VALUES(9,'ST250G');
INSERT INTO ProductToPrintMedia(ProductId, MediaCode) VALUES(9,'ST300G');



INSERT INTO ProductToDataTemplate(DataTemplateId, ProductId) VALUES(1,1);
INSERT INTO ProductToDataTemplate(DataTemplateId, ProductId) VALUES(2,1);
INSERT INTO ProductToDataTemplate(DataTemplateId, ProductId) VALUES(3,1);
INSERT INTO ProductToDataTemplate(DataTemplateId, ProductId) VALUES(4,1);
INSERT INTO ProductToDataTemplate(DataTemplateId, ProductId) VALUES(5,1);
INSERT INTO ProductToDataTemplate(DataTemplateId, ProductId) VALUES(6,1);

INSERT INTO ProductToDataTemplate(DataTemplateId, ProductId) VALUES(1,2);
INSERT INTO ProductToDataTemplate(DataTemplateId, ProductId) VALUES(2,2);
INSERT INTO ProductToDataTemplate(DataTemplateId, ProductId) VALUES(3,2);
INSERT INTO ProductToDataTemplate(DataTemplateId, ProductId) VALUES(4,2);
INSERT INTO ProductToDataTemplate(DataTemplateId, ProductId) VALUES(5,2);
INSERT INTO ProductToDataTemplate(DataTemplateId, ProductId) VALUES(6,2);

INSERT INTO ProductToDataTemplate(DataTemplateId, ProductId) VALUES(1,3);
INSERT INTO ProductToDataTemplate(DataTemplateId, ProductId) VALUES(2,3);
INSERT INTO ProductToDataTemplate(DataTemplateId, ProductId) VALUES(3,3);
INSERT INTO ProductToDataTemplate(DataTemplateId, ProductId) VALUES(4,3);
INSERT INTO ProductToDataTemplate(DataTemplateId, ProductId) VALUES(5,3);
INSERT INTO ProductToDataTemplate(DataTemplateId, ProductId) VALUES(6,3);

INSERT INTO ProductToDataTemplate(DataTemplateId, ProductId) VALUES(1,4);
INSERT INTO ProductToDataTemplate(DataTemplateId, ProductId) VALUES(2,4);
INSERT INTO ProductToDataTemplate(DataTemplateId, ProductId) VALUES(3,4);
INSERT INTO ProductToDataTemplate(DataTemplateId, ProductId) VALUES(4,4);
INSERT INTO ProductToDataTemplate(DataTemplateId, ProductId) VALUES(5,4);
INSERT INTO ProductToDataTemplate(DataTemplateId, ProductId) VALUES(6,4);

INSERT INTO ProductToDataTemplate(DataTemplateId, ProductId) VALUES(1,5);
INSERT INTO ProductToDataTemplate(DataTemplateId, ProductId) VALUES(2,5);
INSERT INTO ProductToDataTemplate(DataTemplateId, ProductId) VALUES(3,5);
INSERT INTO ProductToDataTemplate(DataTemplateId, ProductId) VALUES(4,5);
INSERT INTO ProductToDataTemplate(DataTemplateId, ProductId) VALUES(5,5);
INSERT INTO ProductToDataTemplate(DataTemplateId, ProductId) VALUES(6,5);

INSERT INTO ProductToDataTemplate(DataTemplateId, ProductId) VALUES(1,6);
INSERT INTO ProductToDataTemplate(DataTemplateId, ProductId) VALUES(2,6);
INSERT INTO ProductToDataTemplate(DataTemplateId, ProductId) VALUES(3,6);
INSERT INTO ProductToDataTemplate(DataTemplateId, ProductId) VALUES(4,6);
INSERT INTO ProductToDataTemplate(DataTemplateId, ProductId) VALUES(5,6);
INSERT INTO ProductToDataTemplate(DataTemplateId, ProductId) VALUES(6,6);

INSERT INTO ProductToDataTemplate(DataTemplateId, ProductId) VALUES(1,7);
INSERT INTO ProductToDataTemplate(DataTemplateId, ProductId) VALUES(2,7);
INSERT INTO ProductToDataTemplate(DataTemplateId, ProductId) VALUES(3,7);
INSERT INTO ProductToDataTemplate(DataTemplateId, ProductId) VALUES(4,7);
INSERT INTO ProductToDataTemplate(DataTemplateId, ProductId) VALUES(5,7);
INSERT INTO ProductToDataTemplate(DataTemplateId, ProductId) VALUES(6,7);

INSERT INTO ProductToDataTemplate(DataTemplateId, ProductId) VALUES(1,8);
INSERT INTO ProductToDataTemplate(DataTemplateId, ProductId) VALUES(2,8);
INSERT INTO ProductToDataTemplate(DataTemplateId, ProductId) VALUES(3,8);
INSERT INTO ProductToDataTemplate(DataTemplateId, ProductId) VALUES(4,8);
INSERT INTO ProductToDataTemplate(DataTemplateId, ProductId) VALUES(5,8);
INSERT INTO ProductToDataTemplate(DataTemplateId, ProductId) VALUES(6,8);

INSERT INTO ProductToDataTemplate(DataTemplateId, ProductId) VALUES(1,9);
INSERT INTO ProductToDataTemplate(DataTemplateId, ProductId) VALUES(2,9);
INSERT INTO ProductToDataTemplate(DataTemplateId, ProductId) VALUES(3,9);
INSERT INTO ProductToDataTemplate(DataTemplateId, ProductId) VALUES(4,9);
INSERT INTO ProductToDataTemplate(DataTemplateId, ProductId) VALUES(5,9);
INSERT INTO ProductToDataTemplate(DataTemplateId, ProductId) VALUES(6,9);

DELETE FROM ProductToPricePolicy;
DELETE FROM PricePolicy;
--DBCC CHECKIDENT(PricePolicy,RESEED, 0);
INSERT INTO PricePolicy(LocaleNameKey, Quantity, Price, ActiveFrom) VALUES ('standard', 100, 500, 10-10-2005);

INSERT INTO ProductToPricePolicy(PricePolicyId,ProductId) VALUES (1, 1);
INSERT INTO ProductToPricePolicy(PricePolicyId,ProductId) VALUES (1, 2);
INSERT INTO ProductToPricePolicy(PricePolicyId,ProductId) VALUES (1, 3);
INSERT INTO ProductToPricePolicy(PricePolicyId,ProductId) VALUES (1, 4);
INSERT INTO ProductToPricePolicy(PricePolicyId,ProductId) VALUES (1, 5);
INSERT INTO ProductToPricePolicy(PricePolicyId,ProductId) VALUES (1, 6);
INSERT INTO ProductToPricePolicy(PricePolicyId,ProductId) VALUES (1, 7);
INSERT INTO ProductToPricePolicy(PricePolicyId,ProductId) VALUES (1, 8);
INSERT INTO ProductToPricePolicy(PricePolicyId,ProductId) VALUES (1, 9);


DELETE FROM PrintPricePolicy;
--DBCC CHECKIDENT(PrintPricePolicy,RESEED, 0);

INSERT INTO PrintPricePolicy(PrintMediaCode, PrintMethodCode, ProductCode, Price, Quantity, ActiveFrom) 
VALUES ('ST250G', 'LASR40', 'BCARD', 4000, 100, 10-10-2005);
INSERT INTO PrintPricePolicy(PrintMediaCode, PrintMethodCode, ProductCode, Price, Quantity, ActiveFrom) 
VALUES ('ST250G', 'LASR40', 'BCARD', 7000, 200, 10-10-2005);
INSERT INTO PrintPricePolicy(PrintMediaCode, PrintMethodCode, ProductCode, Price, Quantity, ActiveFrom) 
VALUES ('ST250G', 'LASR40', 'BCARD', 12000, 400, 10-10-2005);
INSERT INTO PrintPricePolicy(PrintMediaCode, PrintMethodCode, ProductCode, Price, Quantity, ActiveFrom) 
VALUES ('ST250G', 'LASR40', 'BCARD', 20000, 700, 10-10-2005);
INSERT INTO PrintPricePolicy(PrintMediaCode, PrintMethodCode, ProductCode, Price, Quantity, ActiveFrom) 
VALUES ('ST250G', 'LASR40', 'BCARD', 26000, 1000, 10-10-2005);

INSERT INTO PrintPricePolicy(PrintMediaCode, PrintMethodCode, ProductCode, Price, Quantity, ActiveFrom) 
VALUES ('ST250G', 'LASR41', 'BCARD', 5000, 100, 10-10-2005);
INSERT INTO PrintPricePolicy(PrintMediaCode, PrintMethodCode, ProductCode, Price, Quantity, ActiveFrom) 
VALUES ('ST250G', 'LASR41', 'BCARD', 9000, 200, 10-10-2005);
INSERT INTO PrintPricePolicy(PrintMediaCode, PrintMethodCode, ProductCode, Price, Quantity, ActiveFrom) 
VALUES ('ST250G', 'LASR41', 'BCARD', 15000, 400, 10-10-2005);
INSERT INTO PrintPricePolicy(PrintMediaCode, PrintMethodCode, ProductCode, Price, Quantity, ActiveFrom) 
VALUES ('ST250G', 'LASR41', 'BCARD', 25000, 700, 10-10-2005);
INSERT INTO PrintPricePolicy(PrintMediaCode, PrintMethodCode, ProductCode, Price, Quantity, ActiveFrom) 
VALUES ('ST250G', 'LASR41', 'BCARD', 33000, 1000, 10-10-2005);

INSERT INTO PrintPricePolicy(PrintMediaCode, PrintMethodCode, ProductCode, Price, Quantity, ActiveFrom) 
VALUES ('ST250G', 'LASR44', 'BCARD', 7000, 100, 10-10-2005);
INSERT INTO PrintPricePolicy(PrintMediaCode, PrintMethodCode, ProductCode, Price, Quantity, ActiveFrom) 
VALUES ('ST250G', 'LASR44', 'BCARD', 13000, 200, 10-10-2005);
INSERT INTO PrintPricePolicy(PrintMediaCode, PrintMethodCode, ProductCode, Price, Quantity, ActiveFrom) 
VALUES ('ST250G', 'LASR44', 'BCARD', 22000, 400, 10-10-2005);
INSERT INTO PrintPricePolicy(PrintMediaCode, PrintMethodCode, ProductCode, Price, Quantity, ActiveFrom) 
VALUES ('ST250G', 'LASR44', 'BCARD', 40000, 700, 10-10-2005);
INSERT INTO PrintPricePolicy(PrintMediaCode, PrintMethodCode, ProductCode, Price, Quantity, ActiveFrom) 
VALUES ('ST250G', 'LASR44', 'BCARD', 60000, 1000, 10-10-2005);

INSERT INTO PrintPricePolicy(PrintMediaCode, PrintMethodCode, ProductCode, Price, Quantity, ActiveFrom) 
VALUES ('ST300G', 'LASR40', 'BCARD', 4400, 100, 10-10-2005);
INSERT INTO PrintPricePolicy(PrintMediaCode, PrintMethodCode, ProductCode, Price, Quantity, ActiveFrom) 
VALUES ('ST300G', 'LASR40', 'BCARD', 7800, 200, 10-10-2005);
INSERT INTO PrintPricePolicy(PrintMediaCode, PrintMethodCode, ProductCode, Price, Quantity, ActiveFrom) 
VALUES ('ST300G', 'LASR40', 'BCARD', 13600, 400, 10-10-2005);
INSERT INTO PrintPricePolicy(PrintMediaCode, PrintMethodCode, ProductCode, Price, Quantity, ActiveFrom) 
VALUES ('ST300G', 'LASR40', 'BCARD', 22800, 700, 10-10-2005);
INSERT INTO PrintPricePolicy(PrintMediaCode, PrintMethodCode, ProductCode, Price, Quantity, ActiveFrom) 
VALUES ('ST300G', 'LASR40', 'BCARD', 30000, 1000, 10-10-2005);

INSERT INTO PrintPricePolicy(PrintMediaCode, PrintMethodCode, ProductCode, Price, Quantity, ActiveFrom) 
VALUES ('ST300G', 'LASR41', 'BCARD', 5400, 100, 10-10-2005);
INSERT INTO PrintPricePolicy(PrintMediaCode, PrintMethodCode, ProductCode, Price, Quantity, ActiveFrom) 
VALUES ('ST300G', 'LASR41', 'BCARD', 9800, 200, 10-10-2005);
INSERT INTO PrintPricePolicy(PrintMediaCode, PrintMethodCode, ProductCode, Price, Quantity, ActiveFrom) 
VALUES ('ST300G', 'LASR41', 'BCARD', 16600, 400, 10-10-2005);
INSERT INTO PrintPricePolicy(PrintMediaCode, PrintMethodCode, ProductCode, Price, Quantity, ActiveFrom) 
VALUES ('ST300G', 'LASR41', 'BCARD', 27800, 700, 10-10-2005);
INSERT INTO PrintPricePolicy(PrintMediaCode, PrintMethodCode, ProductCode, Price, Quantity, ActiveFrom) 
VALUES ('ST300G', 'LASR41', 'BCARD', 37000, 1000, 10-10-2005);

INSERT INTO PrintPricePolicy(PrintMediaCode, PrintMethodCode, ProductCode, Price, Quantity, ActiveFrom) 
VALUES ('ST300G', 'LASR44', 'BCARD', 7400, 100, 10-10-2005);
INSERT INTO PrintPricePolicy(PrintMediaCode, PrintMethodCode, ProductCode, Price, Quantity, ActiveFrom) 
VALUES ('ST300G', 'LASR44', 'BCARD', 13800, 200, 10-10-2005);
INSERT INTO PrintPricePolicy(PrintMediaCode, PrintMethodCode, ProductCode, Price, Quantity, ActiveFrom) 
VALUES ('ST300G', 'LASR44', 'BCARD', 23600, 400, 10-10-2005);
INSERT INTO PrintPricePolicy(PrintMediaCode, PrintMethodCode, ProductCode, Price, Quantity, ActiveFrom) 
VALUES ('ST300G', 'LASR44', 'BCARD', 42800, 700, 10-10-2005);
INSERT INTO PrintPricePolicy(PrintMediaCode, PrintMethodCode, ProductCode, Price, Quantity, ActiveFrom) 
VALUES ('ST300G', 'LASR44', 'BCARD', 64000, 1000, 10-10-2005);



DELETE FROM FinishingPricePolicy;
--DBCC CHECKIDENT(FinishingPricePolicy,RESEED, 0);

DELETE FROM FinishingService;
DELETE FROM FinishingServiceType;
INSERT INTO FinishingServiceType(FinishingServiceType, LocaleNameKey, LocaleDescKey) VALUES('CUTT','cutting','cutting');
INSERT INTO FinishingServiceType(FinishingServiceType, LocaleNameKey, LocaleDescKey) VALUES('LAMN','lamination','lamination');

INSERT INTO FinishingService(FinishingServiceCode, FinishingServiceType, LocaleNameKey, LocaleDescKey, CreateDate)
VALUES('CTRA','CUTT','all_corners_round_cut','all_corners_round_cut',10-10-2005);

INSERT INTO FinishingService(FinishingServiceCode, FinishingServiceType, LocaleNameKey, LocaleDescKey, CreateDate)
VALUES('CTRD','CUTT','diagonal_corners_round_cut','diagonal_corners_round_cut',10-10-2005);

INSERT INTO FinishingService(FinishingServiceCode, FinishingServiceType, LocaleNameKey, LocaleDescKey, CreateDate)
VALUES('LMMT','LAMN','mate_lamination','mate_lamination',10-10-2005);

INSERT INTO FinishingService(FinishingServiceCode, FinishingServiceType, LocaleNameKey, LocaleDescKey, CreateDate)
VALUES('LMGL','LAMN','glossy_lamination','glossy_lamination',10-10-2005);

INSERT INTO FinishingPricePolicy(ProductCode, FinishingServiceCode, PrintMediaCode, Price, Quantity, ActiveFrom)
VALUES('BCARD', 'CTRA', 'ST250G', 1000, 100, 10-10-2005);
INSERT INTO FinishingPricePolicy(ProductCode, FinishingServiceCode, PrintMediaCode, Price, Quantity, ActiveFrom)
VALUES('BCARD', 'CTRA', 'ST250G', 1800, 200, 10-10-2005);
INSERT INTO FinishingPricePolicy(ProductCode, FinishingServiceCode, PrintMediaCode, Price, Quantity, ActiveFrom)
VALUES('BCARD', 'CTRA', 'ST250G', 3200, 400, 10-10-2005);
INSERT INTO FinishingPricePolicy(ProductCode, FinishingServiceCode, PrintMediaCode, Price, Quantity, ActiveFrom)
VALUES('BCARD', 'CTRA', 'ST250G', 5000, 700, 10-10-2005);
INSERT INTO FinishingPricePolicy(ProductCode, FinishingServiceCode, PrintMediaCode, Price, Quantity, ActiveFrom)
VALUES('BCARD', 'CTRA', 'ST250G', 7000, 1000, 10-10-2005);

INSERT INTO FinishingPricePolicy(ProductCode, FinishingServiceCode, PrintMediaCode, Price, Quantity, ActiveFrom)
VALUES('BCARD', 'CTRA', 'ST300G', 1100, 100, 10-10-2005);
INSERT INTO FinishingPricePolicy(ProductCode, FinishingServiceCode, PrintMediaCode, Price, Quantity, ActiveFrom)
VALUES('BCARD', 'CTRA', 'ST300G', 1900, 200, 10-10-2005);
INSERT INTO FinishingPricePolicy(ProductCode, FinishingServiceCode, PrintMediaCode, Price, Quantity, ActiveFrom)
VALUES('BCARD', 'CTRA', 'ST300G', 3300, 400, 10-10-2005);
INSERT INTO FinishingPricePolicy(ProductCode, FinishingServiceCode, PrintMediaCode, Price, Quantity, ActiveFrom)
VALUES('BCARD', 'CTRA', 'ST300G', 5100, 700, 10-10-2005);
INSERT INTO FinishingPricePolicy(ProductCode, FinishingServiceCode, PrintMediaCode, Price, Quantity, ActiveFrom)
VALUES('BCARD', 'CTRA', 'ST300G', 7100, 1000, 10-10-2005);


INSERT INTO FinishingPricePolicy(ProductCode, FinishingServiceCode, PrintMediaCode, Price, Quantity, ActiveFrom)
VALUES('BCARD', 'CTRD', 'ST250G', 800, 100, 10-10-2005);
INSERT INTO FinishingPricePolicy(ProductCode, FinishingServiceCode, PrintMediaCode, Price, Quantity, ActiveFrom)
VALUES('BCARD', 'CTRD', 'ST250G', 1500, 200, 10-10-2005);
INSERT INTO FinishingPricePolicy(ProductCode, FinishingServiceCode, PrintMediaCode, Price, Quantity, ActiveFrom)
VALUES('BCARD', 'CTRD', 'ST250G', 2800, 400, 10-10-2005);
INSERT INTO FinishingPricePolicy(ProductCode, FinishingServiceCode, PrintMediaCode, Price, Quantity, ActiveFrom)
VALUES('BCARD', 'CTRD', 'ST250G', 4600, 700, 10-10-2005);
INSERT INTO FinishingPricePolicy(ProductCode, FinishingServiceCode, PrintMediaCode, Price, Quantity, ActiveFrom)
VALUES('BCARD', 'CTRD', 'ST250G', 6000, 1000, 10-10-2005);

INSERT INTO FinishingPricePolicy(ProductCode, FinishingServiceCode, PrintMediaCode, Price, Quantity, ActiveFrom)
VALUES('BCARD', 'CTRD', 'ST300G', 900, 100, 10-10-2005);
INSERT INTO FinishingPricePolicy(ProductCode, FinishingServiceCode, PrintMediaCode, Price, Quantity, ActiveFrom)
VALUES('BCARD', 'CTRD', 'ST300G', 1600, 200, 10-10-2005);
INSERT INTO FinishingPricePolicy(ProductCode, FinishingServiceCode, PrintMediaCode, Price, Quantity, ActiveFrom)
VALUES('BCARD', 'CTRD', 'ST300G', 2900, 400, 10-10-2005);
INSERT INTO FinishingPricePolicy(ProductCode, FinishingServiceCode, PrintMediaCode, Price, Quantity, ActiveFrom)
VALUES('BCARD', 'CTRD', 'ST300G', 4700, 700, 10-10-2005);
INSERT INTO FinishingPricePolicy(ProductCode, FinishingServiceCode, PrintMediaCode, Price, Quantity, ActiveFrom)
VALUES('BCARD', 'CTRD', 'ST300G', 6100, 1000, 10-10-2005);



INSERT INTO FinishingPricePolicy(ProductCode, FinishingServiceCode, PrintMediaCode, Price, Quantity, ActiveFrom)
VALUES('BCARD', 'LMMT', 'ST250G', 1500, 100, 10-10-2005);
INSERT INTO FinishingPricePolicy(ProductCode, FinishingServiceCode, PrintMediaCode, Price, Quantity, ActiveFrom)
VALUES('BCARD', 'LMMT', 'ST250G', 2500, 200, 10-10-2005);
INSERT INTO FinishingPricePolicy(ProductCode, FinishingServiceCode, PrintMediaCode, Price, Quantity, ActiveFrom)
VALUES('BCARD', 'LMMT', 'ST250G', 4500, 400, 10-10-2005);
INSERT INTO FinishingPricePolicy(ProductCode, FinishingServiceCode, PrintMediaCode, Price, Quantity, ActiveFrom)
VALUES('BCARD', 'LMMT', 'ST250G', 6000, 700, 10-10-2005);
INSERT INTO FinishingPricePolicy(ProductCode, FinishingServiceCode, PrintMediaCode, Price, Quantity, ActiveFrom)
VALUES('BCARD', 'LMMT', 'ST250G', 9000, 1000, 10-10-2005);


INSERT INTO FinishingPricePolicy(ProductCode, FinishingServiceCode, PrintMediaCode, Price, Quantity, ActiveFrom)
VALUES('BCARD', 'LMMT', 'ST300G', 1500, 100, 10-10-2005);
INSERT INTO FinishingPricePolicy(ProductCode, FinishingServiceCode, PrintMediaCode, Price, Quantity, ActiveFrom)
VALUES('BCARD', 'LMMT', 'ST300G', 2500, 200, 10-10-2005);
INSERT INTO FinishingPricePolicy(ProductCode, FinishingServiceCode, PrintMediaCode, Price, Quantity, ActiveFrom)
VALUES('BCARD', 'LMMT', 'ST300G', 4500, 400, 10-10-2005);
INSERT INTO FinishingPricePolicy(ProductCode, FinishingServiceCode, PrintMediaCode, Price, Quantity, ActiveFrom)
VALUES('BCARD', 'LMMT', 'ST300G', 6000, 700, 10-10-2005);
INSERT INTO FinishingPricePolicy(ProductCode, FinishingServiceCode, PrintMediaCode, Price, Quantity, ActiveFrom)
VALUES('BCARD', 'LMMT', 'ST300G', 9000, 1000, 10-10-2005);


INSERT INTO FinishingPricePolicy(ProductCode, FinishingServiceCode, PrintMediaCode, Price, Quantity, ActiveFrom)
VALUES('BCARD', 'LMGL', 'ST250G', 1500, 100, 10-10-2005);
INSERT INTO FinishingPricePolicy(ProductCode, FinishingServiceCode, PrintMediaCode, Price, Quantity, ActiveFrom)
VALUES('BCARD', 'LMGL', 'ST250G', 2500, 200, 10-10-2005);
INSERT INTO FinishingPricePolicy(ProductCode, FinishingServiceCode, PrintMediaCode, Price, Quantity, ActiveFrom)
VALUES('BCARD', 'LMGL', 'ST250G', 4500, 400, 10-10-2005);
INSERT INTO FinishingPricePolicy(ProductCode, FinishingServiceCode, PrintMediaCode, Price, Quantity, ActiveFrom)
VALUES('BCARD', 'LMGL', 'ST250G', 6000, 700, 10-10-2005);
INSERT INTO FinishingPricePolicy(ProductCode, FinishingServiceCode, PrintMediaCode, Price, Quantity, ActiveFrom)
VALUES('BCARD', 'LMGL', 'ST250G', 9000, 1000, 10-10-2005);


INSERT INTO FinishingPricePolicy(ProductCode, FinishingServiceCode, PrintMediaCode, Price, Quantity, ActiveFrom)
VALUES('BCARD', 'LMGL', 'ST300G', 1500, 100, 10-10-2005);
INSERT INTO FinishingPricePolicy(ProductCode, FinishingServiceCode, PrintMediaCode, Price, Quantity, ActiveFrom)
VALUES('BCARD', 'LMGL', 'ST300G', 2500, 200, 10-10-2005);
INSERT INTO FinishingPricePolicy(ProductCode, FinishingServiceCode, PrintMediaCode, Price, Quantity, ActiveFrom)
VALUES('BCARD', 'LMGL', 'ST300G', 4500, 400, 10-10-2005);
INSERT INTO FinishingPricePolicy(ProductCode, FinishingServiceCode, PrintMediaCode, Price, Quantity, ActiveFrom)
VALUES('BCARD', 'LMGL', 'ST300G', 6000, 700, 10-10-2005);
INSERT INTO FinishingPricePolicy(ProductCode, FinishingServiceCode, PrintMediaCode, Price, Quantity, ActiveFrom)
VALUES('BCARD', 'LMGL', 'ST300G', 9000, 1000, 10-10-2005);







